LOAD DATA
characterset UTF8
APPEND INTO TABLE gt_quesroad_base60
FIELDS TERMINATED BY ','
trailing nullcols
(
rangetime date "yyyy-mm-dd hh24:mi:ss",
gridids,
roadname,
roadcnname,
rruid,
abevents,
lon,
lat
)